mysql optimise table

Yesterday when the backend program read the database information, the Log Report related data table can not read and write data, into the MySQL database found table './wordpress/wp_posts ' is marked as crashed and should be repaired Error because

Introduction of Mysqlcheck The Mysqlcheck client can examine and repair the MyISAM table. It can also optimize and analyze tables. Mysqlcheck function is similar to MYISAMCHK, but its work is different. The main difference is that when the MYSQLD

Method One, modify directly in command mode 1, Myisamchk To fix the MySQL database, there is also a command: Mysqlcheck Mysqlcheck-a-c-o-r–all-databases-uroot-p//This command is the best way to optimize all DB databases. The meaning of the

Mysql database optimization and restoration tool mysqlcheck details 1. Introduction to mysqlcheck The mysqlcheck client can check and repair the MyISAM table. It can also be optimized and analyzed. The function of mysqlcheck is similar to that of

mysql database Mysqlcheck The use of knowledge is the main content of this article, we know, Mysqlcheck, is the MySQL comes with can check and repair MyISAM table, And it can also optimize and analyze tables, mysqlcheck functions like Myisamchk, but

Transfer from Http://www.jianshu.com/p/NsWbRvWork needs to learn from MySQL for the specific implementation of select, in the online search for a long time, almost all of the introduction of the principle, for the implementation of details are not